﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'InsertConstraintType')
	BEGIN
		DROP  Procedure  InsertConstraintType
	END

GO

CREATE Procedure InsertConstraintType
	(
		@name varchar(255)
	)
AS
begin

	declare @id uniqueidentifier;
	set @id=newid();
	Insert Into [Constraint_type]
		(CONS_TYP_ID,CONS_TYP_NAME) values (@id,@name);
		
	select @id;

end

GO



/*
GRANT EXEC ON Stored_Procedure_Name TO PUBLIC

GO
*/

